VBA在环境监测数据统计中的应用

VBA是Office系列软件内嵌的通用编程语言,用于定制和扩展Office的功能。将VBA应用在环境监测数据统计中,并以功能区噪声等效声级日期筛选为例,通过编制宏代码,方便快捷地实现功能区噪声数据的自动筛选。     

不同生态系统土壤生化特征及其与土壤呼吸和N2O排放的关系

通过室内培养实验,研究了不同生态系统土壤生化特征及其对土壤呼吸和N2O排放的影响.结果表明,不同生态系统土壤的生化特征不同,土壤呼吸和N2O排放也不相同.一般果园细菌数量最多,草地放线菌数量最多,林地真菌数量最多,而竹园细菌放线菌数量最少,果园真菌最少;微生物碳氮含量一般果园>林地>农田.相关分析表明细菌数量与微生物碳氮呈显著正相关,放线菌数量与土壤有机碳和全氮含量呈极显著正相关(P<0.01),而真菌数量仅与全氮含量呈显著正相关(P<0.05).土壤呼吸累积排放量从高到低为果园>竹林>农田>林地>草地.N2O累积排放量为农田>果园>草地>林地>竹林.土壤呼吸与细菌、微生物碳氮呈显著正相关(P<0.05);土壤的N2O排放与三大微生物、铵态氮呈显著正相关(P<0.05).逐步回归分析表明土壤呼吸主要取决于土壤细菌数量和pH的变化;土壤N2O排放主要取决于土壤细菌数量和铵态氮含量的变化.     

不同温度下微生物和纤维素酶对发酵猪粪理化特性的影响

采用恒温发酵培养试验,研究了5℃和25℃时分别接种纤维素酶(X)、枯草芽孢杆菌(K)和EM菌(E)及其组合对新鲜猪粪发酵中的全氮、铵态氮、有机质、p H及微生物数量的影响.结果表明,5℃条件下,猪粪中微生物生长受抑制,细菌、真菌、放线菌数量均明显低于25℃,发酵终期猪粪有机质含量为70%~83%,p H值为7.16~7.36;25℃条件时,发酵终期猪粪有机质含量降至61%~72%,p H值升至8.09~8.94.与对照相比较,25℃下添加微生物和纤维素酶的处理有机质含量降低了2.95%~7.70%(除了K和XE处理),C/N值降低了4.04%~37.59%(除了XK处理),p H值增加了1.7%~26.8%.在总的添加量一致的条件下,发酵剂组合KE、XE、XK、XKE对猪粪发酵的效果优于单一发酵剂的X、K、E处理.     

重金属污染土壤的植物修复技术研究进展探讨

大多数传统的重金属污染治理技术成本高,会引起土壤肥力下降,对各类生态系统造成负面影响。植物修复技术是一种成本低、环境友好的方法,不会对土壤性质和生态系统产生不利影响。文章综述了植物修复治理重金属污染土壤的研究进展,探讨如何通过采取物理、化学、生物技术及农艺措施等方法提高修复植物的生物量和重金属积累量并展望了今后的研究方向。     

基于土壤气调查的废弃工业场地人体健康风险评估研究

土壤气采样和分析是蒸气侵入评估的一个常用的工具.以某废弃化工场地为研究区,采集污染区域10个点位处的土壤气（编号SG1至SG10）,并分析土壤气中的苯、乙苯、四氯化碳、三氯乙烯、四氯乙烯和三氯甲烷等挥发性有机物.根据测定的土壤气体浓度,结合Johnson ＆amp;Ettinger（J＆amp;E）侵入模型评估了该废弃场地土壤气中挥发性有机物侵入带来的人体健康风险.风险评估结果表明,SG5与SG6处非致癌风险指数大于1,而10个采样点位中有9个（除SG8处）的单一污染物可接受致癌风险均超过1.0E-6.相对于非致癌风险,致癌风险存在面更加广泛,同时程度也比较严重,在进行场地再开发之前需要考虑场地修复等风险管理措施.     

黄连根茎浸提物对绿藻的毒理作用

黄连根茎和制剂具有抗菌等作用,广泛用于水产养殖,所造成水生态风险需要评估.试验设置总生物碱为0(CK),0.088(T1)、0.44(T2)和1.76 mg·L-1(T3)的黄连根茎浸提液(CRE)4种处理,研究了对斜生栅藻和蛋白核小球藻的毒理作用.结果表明,T1抑制绿藻生长,T2和T3使绿藻生长和繁殖停止;它们均显著降低绿藻叶绿素和蛋白质含量,说明CRE抑制光合作用和蛋白质合成是绿藻生长繁殖速率降低和死亡的直接原因.CRE使氢离子和胞内物质外流,导致藻液p H值显著降低和电导率提高.在T1和T2处理中,绿藻细胞SOD活性先升后降;在T3处理中,SOD活性显著降低.说明在CRE暴露初期,低中浓度的CRE诱导绿藻细胞产生抗性,随暴露时间增长或直接暴露在高浓度的CRE下,抗氧化酶系统被破坏.同样,随着CRE浓度增大,丙二醛含量增加,意味着绿藻细胞膜结构破坏,透性增加.CRE总体上对蛋白核小球藻的危害作用大于斜生栅藻.在水产养殖中,滥用黄连根茎或制剂,以及大规模集约化种植黄连对水体初级生产力具有潜在的生态风险.     

G20峰会期间杭州地区空气质量特征及气象条件分析

利用空气质量和气象要素的监测资料与再分析资料,分析了2016年G20峰会期间(2016年8月10日—9月20日)杭州及周边地区空气质量演变及区域特征,探讨了气象条件对G20峰会期间杭州空气质量的影响.结果表明:G20峰会管控期间,由于机动车排放大幅度降低,杭州NO_2浓度较管控前有所下降,对比周边城市降幅居于首位;而由于不利气象条件的影响,PM_(2.5)、PM_(10)、SO_2、CO和O_3浓度比管控前有不同程度的增长,但增幅相比周边城市较小,说明管控措施对杭州空气质量有一定的改善效果.9月7日管控措施结束后污染反弹现象明显.气象条件对杭州的空气质量有重要影响:在管控前,杭州晴热高温天气有利于O3的生成,偏东风相对洁净,污染传输较少;在管控期,杭州虽受到静稳天气和外来污染传输的影响,但得益于减排应急管控措施的有效实施,NO_2浓度下降幅度最大,其他污染物的增幅也较周边城市偏小;在管控后,气象条件不利于污染物的垂直扩散,受静稳天气和污染源恢复常态的影响,PM_(2.5)、PM_(10)、NO_2、SO_2和CO出现了整个研究时段的最大值,而台风"莫兰蒂"使得杭州PM_(2.5)、PM_(10)和O_3浓度出现了整个研究时段的最低值.     

Food chain transfer of cadmium and lead to cattle in a lead–zinc smelter in Guizhou, China

Cadmium (Cd) and Lead (Pb) are environmental pollutants. Environmental samples and bovine tissues were collected from the areas around a lead–zinc smelter in Guizhou, China for Cd, Pb, zinc (Zn) and copper (Cu) analysis. Cd in soil (10 mg/kg) and feed (6.6 mg/kg) from the polluted areas was 10 times higher than the Chinese Standards, resulting in higher Cd in bovine kidney (38 mg/kg) and liver (2.5 mg/kg). Pb in feed (132 mg/kg) from the polluted area was much higher than unpolluted areas, causing higher Pb levels in bovine tissues. Environmental Zn was elevated, but bovine tissue Zn was normal. Cu in bovine liver decreased with increased Cd and Pb. Metals in drinking water and in bovine muscle were within the Standard range. Thus, in the areas of this lead–zinc smelter, the environment has been contaminated with Cd and Pb, which has been transferred to cattle through the food chain.     

非水相硝基苯在含水层中的迁移释放规律

通过室内模拟实验,探讨了在非水相硝基苯污染含水层的条件下,其在含水层中的迁移及释放规律。迁移规律表明,非水相硝基苯并非在含水层中直接进行垂向迁移,而是一方面在自身重力作用下向含水层下部迁移,另一方面在地下水流的作用下随地下水同向运移,整体表现为随地下水流的侧向运移,并最终迁移至含水层底部。释放规律表明,非水相硝基苯在含水层迁移的过程中会向地下水大量释放,释放出的硝基苯在水流的作用下随地下水同向运移,污染源及迁移至含水层底部的非水相硝基苯均存在再次释放。     

The Importance of Temporal and Spatial Vegetation Structure Information in Biotope Mapping Schemes: A Case Study in Helsingborg,Sweden

Temporal and spatial vegetation structure has impact on biodiversity qualities. Yet, current schemes of biotope mapping do only to a limited extend incorporate these factors in the mapping. The purpose of this study is to evaluate the application of a modified biotope mapping scheme that includes temporal and spatial vegetation structure. A refined scheme was developed based on a biotope classification, and applied to a green structure system in Helsingborg city in southern Sweden. It includes four parameters of vegetation structure: continuity of forest cover, age of dominant trees, horizontal structure, and vertical structure. The major green structure sites were determined by interpretation of panchromatic aerial photographs assisted with a field survey. A set of biotope maps was constructed on the basis of each level of modified classification. An evaluation of the scheme included two aspects in particular: comparison of species richness between long-continuity and short-continuity forests based on identification of woodland continuity using ancient woodland indicators (AWI) species and related historical documents, and spatial distribution of animals in the green space in relation to vegetation structure. The results indicate that (1) the relationship between forest continuity: according to verification of historical documents, the richness of AWI species was higher in long-continuity forests; Simpson’s diversity was significantly different between long- and short-continuity forests; the total species richness and Shannon’s diversity were much higher in long-continuity forests shown a very significant difference. (2) The spatial vegetation structure and age of stands influence the richness and abundance of the avian fauna and rabbits, and distance to the nearest tree and shrub was a strong determinant of presence for these animal groups. It is concluded that continuity of forest cover, age of dominant trees, horizontal and vertical structures of vegetation should now be included in urban biotope classifications.